|
Author |
Thread Statistics | Show CCP posts - 8 post(s) |
Jack Hayson
Atztech Inc. Ixtab.
20
|
Posted - 2014.12.05 22:27:11 -
[1] - Quote
+1 Would be nice to have the SDE data of the new systems. Technically our mapper can handle unknown systems just fine, but it would be a PITA to add the regions,constellations, classes, etc. of all those systems manually to the database. (I'm lazy :-P) |
Jack Hayson
Atztech Inc. Ixtab.
20
|
Posted - 2014.12.06 09:05:47 -
[2] - Quote
Jack Tronic wrote:I just extract all the new systems out of the game cache :D Sounds like... effort. :-/ I'm not that desperate... yet.
Risingson wrote:cynical demands. script them from crest and you can sleep again. Does that part of CREST work yet? Last time I checked it didn't.
|
Jack Hayson
Atztech Inc. Ixtab.
20
|
Posted - 2014.12.06 13:59:54 -
[3] - Quote
Ok, I managed to fetch the new systems via Sisi's Public-CREST: SQL export The endpoint seems really unfinished and is missing some data (e.g. x,y,z of regions), but those should be all new systems.
The interesting part is that there are only two new regions: one containing Thera and one containing 25 other systems. The other 75 systems are in new constellations but in regions that already existed in the Phoebe SDE.
|
Jack Hayson
Atztech Inc. Ixtab.
33
|
Posted - 2014.12.09 13:16:16 -
[4] - Quote
Daimian Mercer wrote:anybody know how to link the dmgTypeEffects for wormhole effects to an actual system? Trying to figure out new wormholes effects. I know the effects are in the SDE - just never been able to link them to a system without my own custom table. Interesting... finding the effect beacons was easy. I got the typeID from (select * FROM mapDenormalize WHERE itemName='Unknown Anomaly') and then the name of the effect from the invTypes table.
However I am completely lost how to connect the beacons to their effect on your ship. I can't find their typeID in any of the dgm tables. :-/ There also isn't a difference between the typeID of e.g. a C1 Magnetar beacon and a C6 Magnetar beacon. |
Jack Hayson
Atztech Inc. Ixtab.
33
|
Posted - 2014.12.09 14:31:03 -
[5] - Quote
Bloemkoolsaus wrote:Jack Hayson wrote:However I am completely lost how to connect the beacons to their effect on your ship. I can't find their typeID in any of the dgm tables. :-/ There also isn't a difference between the typeID of e.g. a C1 Magnetar beacon and a C6 Magnetar beacon. Try this: SELECT i.typename, t.attributename, t.displayname, a.valuefloat, t.unitid FROM dgmtypeattributes a INNER JOIN dgmattributetypes t ON t.attributeid = a.attributeid INNER JOIN invtypes i ON i.typeid = a.typeid WHERE i.typename LIKE '%pulsar%'
Ahh... how did I miss that? Thank you! :-) |
|
|
|